io.snappydata.hydra.cluster.SnappyPrms-pointLookUpQueryList =
" SELECT * FROM Orders WHERE OrderID = 10506"
" SELECT EmployeeID, CustomerID FROM Orders WHERE OrderID = 10267"
" SELECT EmployeeID,OrderDate,RequiredDate,ShippedDate FROM Orders WHERE OrderID = 10276"
" SELECT ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry FROM Orders WHERE OrderID = 10306"
" SELECT OrderID, Freight FROM Orders WHERE OrderID = 10338"
" SELECT Freight * 1.1 AS FreightTotal FROM Orders WHERE OrderID = 10386"
" SELECT OrderID, Freight, Freight * 1.1 AS FreightTotal FROM Orders WHERE OrderID = 10494"
" SELECT OrderID, Freight, Freight * 1.1 AS FreightTotal FROM Orders WHERE OrderID = 10570"
" SELECT OrderID, Freight, Freight * 1.1 AS FreightTotal FROM Orders WHERE OrderID = 10619"
" SELECT OrderID, Freight, Freight * 1.1 AS FreightTotal FROM Orders WHERE OrderID = 10680"
" SELECT CustomerID FROM Orders WHERE OrderID = 10290"
" SELECT SUM(Quantity) AS TotalUnits FROM Order_Details WHERE OrderID = 10340"
" SELECT ProductID, UnitPrice FROM Order_Details WHERE OrderID = 10260"
" SELECT AVG(UnitPrice) AS AveragePrice FROM Order_Details WHERE OrderID = 10280"
" SELECT UnitPrice,Quantity,Discount FROM Order_Details WHERE OrderID = 10306"
" SELECT UnitPrice FROM Order_Details WHERE OrderID = 10323"
" SELECT Quantity FROM Order_Details WHERE OrderID = 10357"
" SELECT Discount FROM Order_Details WHERE OrderID = 10375"
" SELECT Sum(UnitPrice * Quantity * Discount) AS ProductSales  FROM Order_Details WHERE OrderID = 10411"
" SELECT sum(UnitPrice * Quantity * (1 - Discount)) as Subtotal FROM Order_Details WHERE OrderID = 10451"
" SELECT distinct OrderID FROM Order_Details WHERE OrderID = 11077"
" SELECT OrderID,ProductID,UnitPrice,Quantity,Discount FROM Order_Details WHERE OrderID = 11039"
" SELECT * FROM Order_Details WHERE OrderID = 10995"
" SELECT OrderID, ProductID, Quantity, UnitPrice, UnitPrice*Quantity FROM order_details WHERE OrderID = 10975"
" SELECT distinct sum(UnitPrice * Quantity * (1 - Discount)) as Subtotal from order_details where OrderID=10871"
" SELECT LastName,FirstName FROM Employees where (City='London' AND Country='UK')"
" SELECT EmployeeID,LastName,FirstName,Title FROM Employees where (City='Seattle' AND Country='USA')"
" SELECT LastName,FirstName,BirthDate,HireDate,Address FROM Employees where (City='Tacoma' AND Country='USA')"
" SELECT TitleOfCourtesy, FirstName, LastName FROM Employees where (City='Kirkland' AND Country='USA')"
" SELECT CONCAT(FirstName, ' ', LastName) FROM Employees where (City='Redmond' AND Country='USA')"
" SELECT FirstName, LastName, BirthDate FROM Employees where (City='Kirkland' AND Country='USA')"
" SELECT COUNT(DISTINCT City) AS NumCities FROM Employees where (City='London' AND Country='UK')"
" SELECT COUNT(DISTINCT EmployeeID) AS numEmployees FROM Employees where (City='London' AND Country='UK')"
" SELECT COUNT(EmployeeID) AS totalEmployees FROM Employees where (City='London' AND Country='UK')"
" SELECT LastName,FirstName,HomePhone,Extension FROM Employees where (City='Seattle' AND Country='USA')"
" SELECT EmployeeID,LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,PostalCode,Country,HomePhone,Extension,Notes,ReportsTo,PhotoPath FROM Employees where (City='London' AND Country='UK')"
" SELECT LastName,FirstName,Address,City,Region,PostalCode FROM Employees where (City='London' AND Country='UK')"
" SELECT SupplierID FROM Products WHERE (ProductID=14 AND SupplierID=6)"
" SELECT ProductName, UnitsInStock, ReorderLevel FROM Products WHERE (ProductID = 75 AND SupplierID = 12)"
" SELECT EmployeeID,LastName,FirstName,Title,TitleOfCourtesy,BirthDate,HireDate,Address,City,Region,PostalCode,Country,HomePhone,Extension,Notes,ReportsTo,PhotoPath from Employees where (City='London' AND Country='UK')"
" SELECT * from Customers  where (City='London' AND Country='UK')"
" SELECT CustomerID,CompanyName,ContactName,ContactTitle,Address from Customers  where (City='Berlin' AND Country='Germany')"
" SELECT CustomerID,City,Region,PostalCode from Customers  where (City='México D.F.' AND Country='Mexico')"
" SELECT CustomerID,ContactName,ContactTitle from Customers  where (City='Luleå' AND Country='Sweden')"
" SELECT ContactName,CompanyName,City,Country,Region from Customers  where (City='Strasbourg' AND Country='France')"
" SELECT CustomerID As CustomerID_London from Customers  where (City='Tsawassen' AND Country='Canada')"
" SELECT SupplierID,CompanyName from suppliers where SupplierID=25"
" SELECT * from suppliers where SupplierID=25"
" SELECT ContactName,ContactTitle,Address from suppliers where SupplierID=29"
" SELECT SupplierID,CompanyName from suppliers where SupplierID=20"
" SELECT RegionID,TerritoryDescription from territories where TerritoryID=44122"
/* " SELECT ProductName, SupplierID FROM Products WHERE (SupplierID IN (SELECT SupplierID FROM
Suppliers WHERE CompanyName IN ('Exotic Liquids', 'Grandma Kelly''s Homestead', 'Tokyo Traders'))
 AND ProductID=14)" */
;
